insert into RafikiDB.dbo.EntityRelationships(entity1id,entity2id,RelationshipName)
SELECT        dbo.Entity.EntityID AS entity1id, Entity_1.EntityID AS entity2id,  'Has Transcript' as relationshipname
FROM            dbo.Entity INNER JOIN
                         dbo.Entity AS Entity_1 ON dbo.Entity.FriendlyID = Entity_1.FriendlyID
WHERE        (dbo.Entity.EntityType = N'Person') AND (Entity_1.EntityType = N'Transcript') 

